home *** CD-ROM | disk | FTP | other *** search
/ 95.86.62.111 / 95.86.62.111.tar / 95.86.62.111 / Skripti / suspect baza.sql < prev   
Text File  |  2011-10-22  |  266b  |  7 lines
  1. EXEC sp_resetstatus 'yourDBname';
  2. ALTER DATABASE yourDBname SET EMERGENCY
  3. DBCC checkdb('yourDBname')
  4. ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  5. DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
  6. ALTER DATABASE yourDBname SET MULTI_USER
  7.